


USE [OPF]
GO

/****** Object:  Table [dbo].[Inscripcion]    Script Date: 10/26/2014 11:19:53 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Inscripcion](
	[usuario] [varchar](50) NOT NULL,
	[fechaAltaPartido] [datetime] NOT NULL,
	[codModalidad] [int] NOT NULL,
 CONSTRAINT [PK_Inscripcion] PRIMARY KEY CLUSTERED 
(
	[usuario] ASC,
	[fechaAltaPartido] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO



USE [OPF]
GO

/****** Object:  Table [dbo].[Jugador]    Script Date: 10/26/2014 11:20:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Jugador](
	[usuario] [varchar](50) NOT NULL,
	[nombre] [varchar](50) NOT NULL,
	[edad] [int] NOT NULL,
	[email] [varchar](100) NULL,
	[handicap] [int] NOT NULL,
	[esAdministrador] [char](1) NOT NULL,
 CONSTRAINT [PK_Jugador] PRIMARY KEY CLUSTERED 
(
	[usuario] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO



USE [OPF]
GO

/****** Object:  Table [dbo].[JugadorAmigos]    Script Date: 10/26/2014 11:20:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[JugadorAmigos](
	[usuario] [varchar](50) NOT NULL,
	[usuarioAmigo] [varchar](50) NOT NULL,
 CONSTRAINT [PK_JugadorAmigos] PRIMARY KEY CLUSTERED 
(
	[usuario] ASC,
	[usuarioAmigo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [OPF]
GO

/****** Object:  Table [dbo].[JugadorCalificacion]    Script Date: 10/26/2014 11:20:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[JugadorCalificacion](
	[usuario] [varchar](50) NOT NULL,
	[fechaAltaPartido] [datetime] NOT NULL,
	[usuarioCalificador] [varchar](50) NOT NULL,
	[nota] [int] NOT NULL,
 CONSTRAINT [PK_JugadorCalificacion] PRIMARY KEY CLUSTERED 
(
	[usuario] ASC,
	[fechaAltaPartido] ASC,
	[usuarioCalificador] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [OPF]
GO

/****** Object:  Table [dbo].[JugadorCalificacion]    Script Date: 10/26/2014 11:21:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[JugadorCalificacion](
	[usuario] [varchar](50) NOT NULL,
	[fechaAltaPartido] [datetime] NOT NULL,
	[usuarioCalificador] [varchar](50) NOT NULL,
	[nota] [int] NOT NULL,
 CONSTRAINT [PK_JugadorCalificacion] PRIMARY KEY CLUSTERED 
(
	[usuario] ASC,
	[fechaAltaPartido] ASC,
	[usuarioCalificador] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [OPF]
GO

/****** Object:  Table [dbo].[JugadorInfraccion]    Script Date: 10/26/2014 11:21:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[JugadorInfraccion](
	[usuario] [varchar](50) NOT NULL,
	[fecha] [datetime] NOT NULL,
	[motivo] [varchar](100) NOT NULL,
 CONSTRAINT [PK_JugadorInfraccion] PRIMARY KEY CLUSTERED 
(
	[usuario] ASC,
	[fecha] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [OPF]
GO

/****** Object:  Table [dbo].[Modalidad]    Script Date: 10/26/2014 11:22:07 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Modalidad](
	[codModalidad] [int] NOT NULL,
	[descripcion] [varchar](50) NOT NULL,
 CONSTRAINT [PK_Modalidad] PRIMARY KEY CLUSTERED 
(
	[codModalidad] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [OPF]
GO

/****** Object:  Table [dbo].[Partido]    Script Date: 10/26/2014 11:22:19 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Partido](
	[fechaAlta] [datetime] NOT NULL,
	[descripcion] [varchar](50) NOT NULL,
	[lugar] [varchar](50) NOT NULL,
	[usuarioAdministrador] [varchar](50) NOT NULL,
	[fecha] [datetime] NOT NULL,
 CONSTRAINT [PK_Partido] PRIMARY KEY CLUSTERED 
(
	[fechaAlta] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

